home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
status.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
918b
|
23 lines
/* RCSVER $Id: status.sql,v 1.1 1999-02-24 15:52:14-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
*
* Name: status.sql
* Date: 02/23/1999
* memo: Randy Wood
* Description: Create the status table. this table contains statuses
* that are valid for all equipment types and programs.
* Changes:
************************************************************************* */
CREATE TABLE status
(
status_id NUMBER(38), /* Unique ID of this status */
status_type NUMBER(38), /* Type of status: */
/* 1 = primary */
/* 2 = secondary (etc.) */
equip_type NUMBER(38) /* Type of equipment for this status */
CONSTRAINT ref1_status REFERENCES equiptype(equip_type),
descr VARCHAR2(30), /* Description of status */
CONSTRAINT pk_status PRIMARY KEY (status_id)
);